2024-07-22 10:31:59,242 [ 418746 ] INFO : ClickHouse root is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse (runner:42, check_args_and_update_paths)
2024-07-22 10:31:59,242 [ 418746 ] INFO : Cases dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:86, check_args_and_update_paths)
2024-07-22 10:31:59,242 [ 418746 ] INFO : utils dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/utils (runner:97, check_args_and_update_paths)
2024-07-22 10:31:59,242 [ 418746 ] INFO : base_configs_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/programs/server, binary: /home/ubuntu/_work/_temp/test/build/clickhouse, cases_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration  (runner:99, check_args_and_update_paths)
clickhouse_integration_tests_volume
Running pytest container as: 'docker run   --rm --name clickhouse_integration_tests_59ektl --privileged --dns-search='.' --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-odbc-bridge:/clickhouse-odbc-bridge --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-library-bridge:/clickhouse-library-bridge --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=2cffe1eae894 -e DOCKER_BASE_TAG=1d1c87eee2db -e DOCKER_KERBERIZED_HADOOP_TAG=ce74919e88f5 -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=a2d3dc777d0c   -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e CLICKHOUSE_USE_OLD_ANALYZER=1 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS="--dist=loadfile -n 10 -rfEps --run-id=0 --color=no --durations=0 test_storage_mysql/test.py::test_table_function test_storage_mysql/test.py::test_where test_storage_policies/test.py::test_storage_policy_configuration_change test_store_cleanup/test.py::test_store_cleanup test_system_logs/test_system_logs.py::test_system_logs_engine_expr test_system_logs/test_system_logs.py::test_system_logs_order_by_expr test_system_logs/test_system_logs.py::test_system_logs_settings_expr 'test_table_function_mongodb/test.py::test_auth_source[False]' 'test_table_function_mongodb/test.py::test_complex_data_type[False]' 'test_table_function_mongodb/test.py::test_incorrect_data_type[False]' 'test_table_function_mongodb/test.py::test_missing_columns[False]' 'test_table_function_mongodb/test.py::test_no_credentials[False]' 'test_table_function_mongodb/test.py::test_predefined_connection_configuration[False]' 'test_table_function_mongodb/test.py::test_secure_connection[True]' 'test_table_function_mongodb/test.py::test_simple_select[False]' test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data test_user_valid_until/test.py::test_basic test_user_valid_until/test.py::test_details  -vvv" altinityinfra/integration-tests-runner:9d492c2eec24 '.
Start tests
============================= test session starts ==============================
platform linux -- Python 3.10.12, pytest-7.4.4, pluggy-1.5.0 -- /usr/bin/python3
cachedir: .pytest_cache
rootdir: /ClickHouse/tests/integration
configfile: pytest.ini
plugins: reportlog-0.4.0, random-0.2, repeat-0.9.3, xdist-3.5.0, order-1.0.1, timeout-2.2.0
timeout: 900.0s
timeout method: signal
timeout func_only: False
created: 10/10 workers
10 workers [18 items]

scheduling tests via LoadFileScheduling

test_table_function_mongodb/test.py::test_auth_source[False] 
test_user_valid_until/test.py::test_basic 
test_store_cleanup/test.py::test_store_cleanup 
test_storage_policies/test.py::test_storage_policy_configuration_change 
test_system_logs/test_system_logs.py::test_system_logs_engine_expr 
test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data 
test_storage_mysql/test.py::test_table_function 
[gw1] [  5%] PASSED test_system_logs/test_system_logs.py::test_system_logs_engine_expr 
test_system_logs/test_system_logs.py::test_system_logs_order_by_expr 
[gw1] [ 11%] PASSED test_system_logs/test_system_logs.py::test_system_logs_order_by_expr 
test_system_logs/test_system_logs.py::test_system_logs_settings_expr 
[gw1] [ 16%] PASSED test_system_logs/test_system_logs.py::test_system_logs_settings_expr 
[gw6] [ 22%] PASSED test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data 
[gw0] [ 27%] PASSED test_table_function_mongodb/test.py::test_auth_source[False] 
test_table_function_mongodb/test.py::test_complex_data_type[False] 
[gw0] [ 33%] PASSED test_table_function_mongodb/test.py::test_complex_data_type[False] 
test_table_function_mongodb/test.py::test_incorrect_data_type[False] 
[gw0] [ 38%] PASSED test_table_function_mongodb/test.py::test_incorrect_data_type[False] 
test_table_function_mongodb/test.py::test_missing_columns[False] 
[gw0] [ 44%] PASSED test_table_function_mongodb/test.py::test_missing_columns[False] 
test_table_function_mongodb/test.py::test_no_credentials[False] 
[gw0] [ 50%] PASSED test_table_function_mongodb/test.py::test_no_credentials[False] 
test_table_function_mongodb/test.py::test_predefined_connection_configuration[False] 
[gw0] [ 55%] PASSED test_table_function_mongodb/test.py::test_predefined_connection_configuration[False] 
test_table_function_mongodb/test.py::test_secure_connection[True] 
[gw4] [ 61%] PASSED test_storage_policies/test.py::test_storage_policy_configuration_change 
[gw3] [ 66%] PASSED test_user_valid_until/test.py::test_basic 
test_user_valid_until/test.py::test_details 
[gw3] [ 72%] PASSED test_user_valid_until/test.py::test_details 
[gw0] [ 77%] PASSED test_table_function_mongodb/test.py::test_secure_connection[True] 
test_table_function_mongodb/test.py::test_simple_select[False] 
[gw2] [ 83%] PASSED test_storage_mysql/test.py::test_table_function 
test_storage_mysql/test.py::test_where 
[gw2] [ 88%] PASSED test_storage_mysql/test.py::test_where 
[gw5] [ 94%] PASSED test_store_cleanup/test.py::test_store_cleanup 
[gw0] [100%] PASSED test_table_function_mongodb/test.py::test_simple_select[False] 

=============================== warnings summary ===============================
test_table_function_mongodb/test.py::test_auth_source[False]
test_table_function_mongodb/test.py::test_secure_connection[True]
test_table_function_mongodb/test.py::test_simple_select[False]
  /ClickHouse/tests/integration/helpers/cluster.py:2495: DeprecationWarning: database_names is deprecated. Use list_database_names instead.
    logging.debug(f"Connected to Mongo dbs: {connection.database_names()}")

test_table_function_mongodb/test.py::test_auth_source[False]
  /ClickHouse/tests/integration/test_table_function_mongodb/test.py:227: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead
    admin_db.add_user(

test_table_function_mongodb/test.py::test_complex_data_type[False]
  /ClickHouse/tests/integration/test_table_function_mongodb/test.py:89: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead
    db.add_user("root", "clickhouse")

test_table_function_mongodb/test.py::test_complex_data_type[False]
test_table_function_mongodb/test.py::test_secure_connection[True]
test_table_function_mongodb/test.py::test_simple_select[False]
  /usr/local/lib/python3.10/dist-packages/pymongo/database.py:1247: DeprecationWarning: Creating a user with the read_only option or without roles is deprecated in MongoDB >= 2.6
    warnings.warn("Creating a user with the read_only option "

test_table_function_mongodb/test.py::test_incorrect_data_type[False]
  /ClickHouse/tests/integration/test_table_function_mongodb/test.py:124: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead
    db.add_user("root", "clickhouse")

test_table_function_mongodb/test.py::test_missing_columns[False]
  /ClickHouse/tests/integration/test_table_function_mongodb/test.py:263: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead
    db.add_user("root", "clickhouse")

test_table_function_mongodb/test.py::test_predefined_connection_configuration[False]
  /ClickHouse/tests/integration/test_table_function_mongodb/test.py:186: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead
    db.add_user("root", "clickhouse")

test_table_function_mongodb/test.py::test_secure_connection[True]
  /ClickHouse/tests/integration/test_table_function_mongodb/test.py:145: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead
    db.add_user("root", "clickhouse")

test_table_function_mongodb/test.py::test_simple_select[False]
  /ClickHouse/tests/integration/test_table_function_mongodb/test.py:47: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead
    db.add_user("root", "clickhouse")

-- Docs: https://docs.pytest.org/en/stable/how-to/capture-warnings.html
============================== slowest durations ===============================
69.90s call     test_store_cleanup/test.py::test_store_cleanup
50.23s setup    test_storage_mysql/test.py::test_table_function
22.70s setup    test_table_function_mongodb/test.py::test_simple_select[False]
22.50s call     test_table_function_mongodb/test.py::test_simple_select[False]
22.10s setup    test_table_function_mongodb/test.py::test_secure_connection[True]
19.52s setup    test_table_function_mongodb/test.py::test_auth_source[False]
15.40s setup    test_system_logs/test_system_logs.py::test_system_logs_engine_expr
15.04s setup    test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data
14.96s setup    test_store_cleanup/test.py::test_store_cleanup
14.95s setup    test_user_valid_until/test.py::test_basic
14.82s setup    test_storage_policies/test.py::test_storage_policy_configuration_change
14.70s call     test_user_valid_until/test.py::test_basic
11.54s call     test_storage_policies/test.py::test_storage_policy_configuration_change
7.64s teardown test_storage_mysql/test.py::test_where
4.50s teardown test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data
4.28s call     test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data
3.08s teardown test_user_valid_until/test.py::test_details
2.90s teardown test_table_function_mongodb/test.py::test_simple_select[False]
2.57s call     test_storage_mysql/test.py::test_table_function
2.34s teardown test_system_logs/test_system_logs.py::test_system_logs_settings_expr
2.15s call     test_storage_mysql/test.py::test_where
1.86s teardown test_store_cleanup/test.py::test_store_cleanup
1.76s teardown test_storage_policies/test.py::test_storage_policy_configuration_change
1.00s call     test_table_function_mongodb/test.py::test_secure_connection[True]
0.98s call     test_system_logs/test_system_logs.py::test_system_logs_order_by_expr
0.86s call     test_system_logs/test_system_logs.py::test_system_logs_settings_expr
0.76s call     test_system_logs/test_system_logs.py::test_system_logs_engine_expr
0.70s call     test_table_function_mongodb/test.py::test_complex_data_type[False]
0.66s call     test_user_valid_until/test.py::test_details
0.59s call     test_table_function_mongodb/test.py::test_auth_source[False]
0.28s call     test_table_function_mongodb/test.py::test_no_credentials[False]
0.27s call     test_table_function_mongodb/test.py::test_incorrect_data_type[False]
0.27s call     test_table_function_mongodb/test.py::test_missing_columns[False]
0.26s call     test_table_function_mongodb/test.py::test_predefined_connection_configuration[False]
0.00s teardown test_table_function_mongodb/test.py::test_secure_connection[True]
0.00s teardown test_storage_mysql/test.py::test_table_function
0.00s setup    test_storage_mysql/test.py::test_where
0.00s teardown test_table_function_mongodb/test.py::test_auth_source[False]
0.00s teardown test_user_valid_until/test.py::test_basic
0.00s setup    test_table_function_mongodb/test.py::test_missing_columns[False]
0.00s setup    test_user_valid_until/test.py::test_details
0.00s setup    test_system_logs/test_system_logs.py::test_system_logs_settings_expr
0.00s setup    test_system_logs/test_system_logs.py::test_system_logs_order_by_expr
0.00s setup    test_table_function_mongodb/test.py::test_no_credentials[False]
0.00s setup    test_table_function_mongodb/test.py::test_incorrect_data_type[False]
0.00s setup    test_table_function_mongodb/test.py::test_complex_data_type[False]
0.00s teardown test_table_function_mongodb/test.py::test_predefined_connection_configuration[False]
0.00s teardown test_system_logs/test_system_logs.py::test_system_logs_engine_expr
0.00s setup    test_table_function_mongodb/test.py::test_predefined_connection_configuration[False]
0.00s teardown test_system_logs/test_system_logs.py::test_system_logs_order_by_expr
0.00s teardown test_table_function_mongodb/test.py::test_missing_columns[False]
0.00s teardown test_table_function_mongodb/test.py::test_no_credentials[False]
0.00s teardown test_table_function_mongodb/test.py::test_complex_data_type[False]
0.00s teardown test_table_function_mongodb/test.py::test_incorrect_data_type[False]
=========================== short test summary info ============================
PASSED test_system_logs/test_system_logs.py::test_system_logs_engine_expr
PASSED test_system_logs/test_system_logs.py::test_system_logs_order_by_expr
PASSED test_system_logs/test_system_logs.py::test_system_logs_settings_expr
PASSED test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data
PASSED test_table_function_mongodb/test.py::test_auth_source[False]
PASSED test_table_function_mongodb/test.py::test_complex_data_type[False]
PASSED test_table_function_mongodb/test.py::test_incorrect_data_type[False]
PASSED test_table_function_mongodb/test.py::test_missing_columns[False]
PASSED test_table_function_mongodb/test.py::test_no_credentials[False]
PASSED test_table_function_mongodb/test.py::test_predefined_connection_configuration[False]
PASSED test_storage_policies/test.py::test_storage_policy_configuration_change
PASSED test_user_valid_until/test.py::test_basic
PASSED test_user_valid_until/test.py::test_details
PASSED test_table_function_mongodb/test.py::test_secure_connection[True]
PASSED test_storage_mysql/test.py::test_table_function
PASSED test_storage_mysql/test.py::test_where
PASSED test_store_cleanup/test.py::test_store_cleanup
PASSED test_table_function_mongodb/test.py::test_simple_select[False]
================== 18 passed, 13 warnings in 94.24s (0:01:34) ==================